<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ include file="/WEB-INF/jsp/common/taglibs.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<script type="text/javascript" src="${ctx}/res/js/systemMonitor/SQLMonitor/SQLMonitorList.js"></script>
</head>
<body>
	<center>
		<table>
			<!-- 查询条件 区域 -->
			<tr>
				<td>
					<div class="list_query">
					<table>
						<form method="post" id="queryForm">
						<tr>
							<td style="text-align: right">
								<label >STARTTIME</label>
							</td>
							<td>
								<input id="startTime" type="text" style="margin-top:10px"
									name="startTime" placeholder="请输入START_TIME" id="startTime" value=""/>
							</td>
							<td style="text-align: right">
								<label>ENDTIME</label>
							</td>
							<td>
								<input id="endTime" type="text" style="margin-top:10px"
									name="endTime" placeholder="请输入END_TIME" value="${currentTime }"/>
							 </td>
							</td>
							<td style="text-align: right">
								<label>EXEC_RESULT</label>
							</td>	
							<td>
								&nbsp;&nbsp;&nbsp;&nbsp;<select id="execResult" style="width:220px;height:32px;font-size:15px"
									name="execResult" />
									<option value="">全部</option>
									<option value="1">成功</option>
									<option value="0">失败</option>
								</select>
							</td>		 
							</tr>
							
							<tr>
							<td style="text-align: right">
								<label>SQL_ID</label>
							</td>
							<td style="text-align: right">
								<input type="text" style="margin-top:10px"
									name="sqlId" placeholder="请输入SQL_ID" id="sqlId" value=""/>
							</td>		
							<td style="text-align: right">
								<label>SQL_CONTENT</label>
							</td>
							<td>	
								<input type="text" style="margin-top:10px"
									name="sqlContent" placeholder="请输入SQL_CONTENT" id="sqlContent" value=""/>
							</td>		
							<td style="text-align: right">
								<label>USERNAME_CN/USERNAME</label>
							</td>
							<td>	
								<input type="text" style="margin-top:10px" name="userName" 
									placeholder="请输入USERNAME_CN/USERNAME" id="userName" value=""/>
							</td>		
						</tr>
					</table>
						<input type="hidden" name="pageType" id="pageType" value="${pageType }" />
						</form>
					</div>
				</td>
			</tr>

			<!-- 按钮操作区域 -->
			<tr>
				<td>
					<div class="list_toolbar">
						<div class="toolButton" onclick="queryButtonClickEvent()">查询</div>
						<div class="toolButton" onclick="getListDetails()">查看详情</div>
					</div>
				</td>
			</tr>

			<!-- 表头区域-->
			<tr>
				<td>
					<table class="list_grid">
						<thead>
							<tr>
								<th>CREATE_TIME</th>
								<th>SQL_ID</th>
								<th>SQL_CONTENT</th>
								<th>EXEC_RESULT</th>
								<th>EXEC_TIME</th>
								<th>URL</th>
								<th>USER_NAME</th>
								<th>SQL_TYPE</th>
								<th>EFFECT_ROWS</th>
								<th style="width: 1px;"></th>
							</tr>
						</thead>
					</table>
				</td>
			</tr>

			<!-- 数据区域 -->
			<tr>
				<td>
					<div class="list_scrollControlDiv">
						<table class="list_grid" style="border-spacing: 0;">
							<tbody id="tBodyList">
							</tbody>
						</table>
					</div>
				</td>
			</tr>

			<!-- 分页控件区域 -->
			<tr>
				<td>
					<div id="pagination" class="pagination"></div>
					<input type="hidden" id="pageType" name="pageType" value="${pageType}"/>
				</td>
			</tr>
		</table>
	</center>

	<form id="submitDetails" method="post" action="${ctx}/systemMonitor/SQLMonitor/SQLMonitorDetails.do">
		<input type="hidden" name="detailsId"/>
	</form>	

</body>
</html>